﻿

if not Exists(select * from sysobjects where name = 'NewsLetterPendingItem' and Xtype = 'U') 
Begin

	Create table dbo.NewsLetterPendingItem (
		Id int identity(1,1) not null,
		CampaignId int not null,
		EmailRecipientId int not null,
		ScheduledStartDate datetime not null,
		CreationDate datetime not null
	)

	alter table dbo.NewsLetterPendingItem add constraint PK_NewsLetterPendingItem_Id primary key (Id)

End